package com.cn.mapper.dao.db5.PartsManagement;

import com.cn.bean.vo.PartsManagement.TeamPersonnel;
import com.cn.bean.vo.bc.UserJob;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface TeamPersonnelDao {
    List<TeamPersonnel> selectTeamPersonnel(@Param("limit") int limit, @Param("page") int page, @Param("username") String username, @Param("name") String name, @Param("jobName") String jobName, @Param("teamName") String teamName);

    //查询班组人员状态为1
    List<TeamPersonnel> selectTeamAuto1(@Param("limit") int limit, @Param("page") int page, @Param("code") String code, @Param("name") String name);
    List<TeamPersonnel> selectTeam(@Param("limit") int limit, @Param("page") int page, @Param("code") String code, @Param("name") String name);

    List<UserJob> selectEmployeeJob(@Param("limit") int limit, @Param("page") int page, @Param("jobName") String jobName, @Param("name") String name, @Param("username") String username);

    int addTeam(@Param("TeamID") int TeamID, @Param("code") String code, @Param("TeamName") String TeamName, @Param("description") String description, @Param("status") int status, @Param("CreationTime") String CreationTime);

    int addEmployeeJob(@Param("childId") int childId, @Param("TeamID") int TeamID, @Param("userId") int userId, @Param("jobId") int jobId, @Param("TPMStatus") int TPMStatus);

    int deleteTeam(@Param("ID") int ID);

    int deleteEmployeeJob(@Param("ID") int ID);

    Integer selectTeamCount(@Param("name") String name);

    List<TeamPersonnel> selectTeamPersonnelTeamId(@Param("TeamID") int TeamID);

    int upDateTeam(@Param("TeamID") int TeamID, @Param("TeamName") String TeamName, @Param("description") String description, @Param("status") int status);

    List<TeamPersonnel> selectAllTeam();
    List<UserJob> selectUserInformation(@Param("limit") int limit, @Param("page") int page,
                                        @Param("name") String name, @Param("username") String username);

    List<UserJob> selectJobInformation(@Param("limit") int limit, @Param("page") int page, @Param("jobName") String jobName);
}
